﻿<%@ page language="C#" CodeBehind="Default.aspx.cs" async="true" EnableEventValidation = "false" autoeventwireup="true" inherits="StreetSmartAdmin.DefaultPage" %>
<%@ Register TagPrefix="CustUserCtrl" TagName="Header" Src="Header.ascx" %>
<%@ Register TagPrefix="CustUserCtrl" TagName="Footer" Src="Footer.ascx" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>Street Smart Energy Admin</title>
    <link type="text/css" rel="stylesheet" href="style.css" />
</head>
<body>
    <form id="form1" runat="server">
    <asp:ScriptManager ID="ScriptManager1" runat="server">
    </asp:ScriptManager>
    <asp:Timer ID="Timer1" runat="server" ontick="Timer1_Tick" Interval="500000">
    </asp:Timer>
    <CustUserCtrl:Header id="Header" runat="server"></CustUserCtrl:Header>
    <div class="mGrid">    
                    <div style="padding:10px">         
                    <img alt="" src="images/logo.jpg" style="height: 79px" />
                    <asp:Label ID="Label10" runat="server" Visible="False"></asp:Label>
                    <asp:Label ID="Label11" runat="server" Visible="False"></asp:Label>
                    <asp:Label ID="Label17" runat="server" Visible="False"></asp:Label>
                    <asp:Label ID="Label18" runat="server" Visible="False"></asp:Label>
                    <asp:Label ID="Label19" runat="server" Visible="False"></asp:Label>
                    <br />
                    <br />
 <b>Search Users:</b>
 <br/>
        <asp:Panel ID="panSearch" runat="server" DefaultButton="ExactSearchButton" Width="100%" >
        <asp:DropDownList ID="SearchDropDownList" runat="server" AutoPostBack="True"
                        onselectedindexchanged="SearchDropDownList_SelectedIndexChanged">   
            <asp:ListItem Value="All">All</asp:ListItem>    
            <asp:ListItem Value="UserID">User ID</asp:ListItem>
            <asp:ListItem Value="FirstName">First Name</asp:ListItem>
            <asp:ListItem Value="LastName">Last Name</asp:ListItem>
            <asp:ListItem Value="StateName">State</asp:ListItem>
            <asp:ListItem Value="Email">Email</asp:ListItem>                       
            <asp:ListItem Value="Phone">Phone & Mobile</asp:ListItem>
            <asp:ListItem Value="CurrentProvider">Provider</asp:ListItem>
            <asp:ListItem Value="TypeOrg">Organisation Type</asp:ListItem>
            <asp:ListItem Value="CompanyName">Company Name</asp:ListItem>          
            <asp:ListItem Value="AccountStatus">Account Status</asp:ListItem>
            <asp:ListItem Value="InsertDate">Date Registered</asp:ListItem>
            <asp:ListItem Value="PreferredDay">Preferred Day</asp:ListItem>
            <asp:ListItem Value="PromotionCode">Promotion Code & Lead Source</asp:ListItem>    
            <asp:ListItem Value="OperatorSSE">Operator</asp:ListItem>    
        </asp:DropDownList>

                    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
                        onselectedindexchanged="DropDownList1_SelectedIndexChanged" 
                        DataSourceID="SqlDataSource6" DataTextField="AccountStatusName" DataValueField="AccountStatusID" />

                    <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" 
                    DataSourceID="SqlDataSource35" DataTextField="PromotionCodeName" DataValueField="PromotionCodeName"
                    onselectedindexchanged="DropDownList2_SelectedIndexChanged" />

                    <asp:DropDownList ID="DropDownList3" runat="Server" AutoPostBack="True"
                        onselectedindexchanged="DropDownList3_SelectedIndexChanged">
                                        <asp:ListItem Value="ACT">ACT</asp:ListItem>
                                        <asp:ListItem Value="NSW">NSW</asp:ListItem>
                                        <asp:ListItem Value="NT">NT</asp:ListItem>
                                        <asp:ListItem Value="QLD">QLD</asp:ListItem>
                                        <asp:ListItem Value="SA">SA</asp:ListItem>
                                        <asp:ListItem Value="TAS">TAS</asp:ListItem>
                                        <asp:ListItem Value="VIC">VIC</asp:ListItem>
                                        <asp:ListItem Value="WA">WA</asp:ListItem>                     
                    </asp:DropDownList>

                    <asp:DropDownList ID="DropDownList4" AutoPostBack="True" runat="server"
                    DataSourceID="SqlDataSource37" DataTextField="CurrentProviderName" DataValueField="CurrentProviderName" />         

                        <asp:DropDownList ID="DropDownList6" runat="server" AutoPostBack="true" 
                        DataSourceID="SqlDataSource36" DataTextField="OperatorName" DataValueField="OperatorName" />

                        <asp:DropDownList ID="DropDownList5" runat="server" AutoPostBack="true">
                        <asp:ListItem Value="RESI">RESI</asp:ListItem>
                        <asp:ListItem Value="SME">SME</asp:ListItem>
                        <asp:ListItem Value="C&I">C&I</asp:ListItem>
                        </asp:DropDownList>

        <asp:TextBox ID="SearchTextBox" runat="server"></asp:TextBox>
                        <asp:Label ID="Label7" runat="server"></asp:Label>
                        <asp:TextBox ID="Date1" runat="server" width="100px" onclick="WdatePicker()" 
                            ontextchanged="Date1_TextChanged"></asp:TextBox>
                        <asp:Label ID="Label8" runat="server"></asp:Label>
                        <asp:TextBox ID="Date2" runat="server" width="100px" onclick="WdatePicker()" 
                            ontextchanged="Date2_TextChanged"></asp:TextBox>
        <asp:Button ID="ExactSearchButton" runat="server" Text="Search" 
                            onclick="ExactSearchButton_Click"/>
                            &nbsp &nbsp
        <asp:Button ID="CreateNew" runat="server" width="80px" onclick="CreateNew_Click" Text="Add New" />
                        <asp:Button ID="Button4" runat="server" onclick="Button4_Click" 
                            Text="Paste Previous Info" />
                        <asp:Button ID="Button5" runat="server" onclick="Button5_Click" 
                            Text="Hide/Show" />
                        <asp:Button ID="Button3" runat="server" onclick="Button3_Click" Text="Export" />
                    <br />
                    <br />
                    
                        <asp:Button ID="Button6" runat="server" onclick="Button6_Click" 
                            Text="Send Email" Visible="true" />
                        <asp:Button ID="Button7" runat="server" onclick="Button7_Click" 
                            Text="Confirm Sending" Visible="false"/>
                        <asp:Button ID="Button8" runat="server" onclick="Button8_Click" Text="Cancel" 
                            Visible="False" />
                        <asp:Button ID="Button9" runat="server" onclick="Button9_Click" 
                        OnClientClick = "return confirm('Are you sure you want to send Bulk Email?');" 
                            Text="Send Bulk Email" Visible="False" />
                        <asp:Button ID="Button10" runat="server"
                        OnClientClick = "return confirm('Are you sure you want to send Bulk Email?');" 
                            Text="Send To All" Visible="true" onclick="Button10_Click" />
                        
                        
                        
        </asp:Panel>
        <br />
        <br />
         <asp:Panel ID="pnlSelectEmail" runat="server" Visible="false">
            <div>
            Receiver:&nbsp;
            <asp:Label ID="lblReceiver" runat="server"></asp:Label>
            <asp:Label ID="lblEmailStatus" runat="server"></asp:Label>
            <asp:Label ID="lblEmailType" runat="server" Visible="False"></asp:Label>
            <br/>
<asp:DropDownList  OnSelectedIndexChanged="ddlEmail_SelectedIndexChanged"  ID="ddlET" runat="server" AutoPostBack="True"
 DataSourceID="SqlETSource"  DataTextField="EmailTemplateName" DataValueField="EmailTemplateID">  
    </asp:DropDownList> 
    Email Template:&nbsp;<asp:label ID="lblTemplateName"  name="lblTemplateName" runat="server" Text="" /> &nbsp;
    Subject:&nbsp;<asp:label ID="lblTemplateSubject"  name="lblTemplateSubject" runat="server" Text="" />  &nbsp;
    Body:<br /><asp:label ID="lblTemplatelogo"  name="lblTemplatelogo" runat="server" Text="" />
    <br /><asp:label ID="lblUserName"  name="lblUserName" runat="server" Text="" />
    <br /><asp:label ID="lblTemplateBody"  name="lblTemplateBody" runat="server" Text="" /> <br />
</div>
<asp:SqlDataSource ID="SqlETSource" runat="server" ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
    SelectCommand="Select EmailTemplateID,EmailTemplateName FROM tblEmailTemplate UNION
        SELECT 0 AS EmailTemplateID, 'Please Select' AS EmailTemplateName" >
</asp:SqlDataSource>
         </asp:Panel>
         <br />
         <asp:Label ID="Label6" runat="server" Text="Page Size"></asp:Label>
                    <asp:DropDownList ID="PageSizeList" runat="server" AutoPostBack="True"
                        onselectedindexchanged="PageSizeList_SelectedIndexChanged">   
                                        <asp:ListItem Value="10">10</asp:ListItem>                                  
                                        <asp:ListItem Value="20">20</asp:ListItem> 
                                        <asp:ListItem Value="50" Selected="true">50</asp:ListItem>
                                        <asp:ListItem Value="100">100</asp:ListItem>
                                        <asp:ListItem Value="200">200</asp:ListItem>
                                        <asp:ListItem Value="500">500</asp:ListItem>
                                        <asp:ListItem Value="1000">1000</asp:ListItem>
                    </asp:DropDownList>        
                        <asp:Label ID="Label13" runat="server" Text="Total Records:"></asp:Label>
                        <asp:Label ID="Label12" runat="server"></asp:Label>
                        <div style="vertical-align:top; height:750px; overflow:auto; width:95%;">
        <asp:GridView ID="GridView1" runat="server" CssClass="mGrid"
            PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" 
            DataSourceID="SqlDataSource0" AutoGenerateColumns="False" 
            DataKeyNames="UserID" AllowPaging="True"
            onselectedindexchanged="GridView1_SelectedIndexChanged" 
            EnableModelValidation="True" PageSize="50" AllowSorting="true">
<AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>
            <Columns>
                <asp:BoundField DataField="UserID" HeaderText="UserID" 
                    SortExpression="UserID" />
                <asp:BoundField DataField="OperatorSSE" HeaderText="Operator" 
                    SortExpression="OperatorSSE" />
                <asp:BoundField DataField="FirstName" HeaderText="FirstName" 
                    SortExpression="FirstName" />
                <asp:BoundField DataField="LastName" HeaderText="LastName" 
                    SortExpression="LastName" />
                <asp:BoundField DataField="TypeOrg" HeaderText="OrgType" 
                    SortExpression="TypeOrg" />
                <asp:BoundField DataField="CompanyName" HeaderText="CompanyName" 
                    SortExpression="CompanyName" />
                <asp:BoundField DataField="Email" HeaderText="Email" 
                    SortExpression="Email" />
                <asp:BoundField DataField="Phone" HeaderText="Phone" 
                    SortExpression="Phone" />
                <asp:BoundField DataField="PromotionCode" HeaderText="PromotionCode" 
                    SortExpression="PromotionCode" />
                <asp:BoundField DataField="StateName" HeaderText="StateName" 
                    SortExpression="StateName" />
                <asp:BoundField DataField="Postcode" HeaderText="Postcode" 
                    SortExpression="Postcode" />               
                <asp:BoundField DataField="StatusName" HeaderText="AccountStatus" 
                    SortExpression="StatusName" />
                    <asp:BoundField DataField="InsertDate" HeaderText="DateRegistered" 
                    SortExpression="InsertDate" />
                    <asp:BoundField DataField="DateConverted" HeaderText="DateConverted" 
                    SortExpression="DateConverted" />
                    <asp:BoundField DataField="PreferredDay" HeaderText="PreferredDay" 
                    SortExpression="PreferredDay" />
                    <asp:BoundField DataField="PreferredTime" HeaderText="PreferredTime" 
                    SortExpression="PreferredTime" /> 
                    <asp:BoundField DataField="G2G_Solar" HeaderText="G2G_Solar" 
                    SortExpression="G2G_Solar" />                         
                    <asp:TemplateField ShowHeader="False">
                    <ItemTemplate>
                        <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" 
                            CommandName="Select" Text="Select"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
      
                    <asp:TemplateField ShowHeader="False">
                    <ItemTemplate>
                        <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" 
                            CommandName="Delete" Text="Delete" OnClientClick="return confirm('Are You Sure to Delete?')"></asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField> 
            </Columns>

<PagerStyle CssClass="pgr"></PagerStyle>
        </asp:GridView>
        </div>
        <br/>
                    <asp:DetailsView ID="DetailsView1" runat="Server" CellPadding="4" ForeColor="#333333"
                        GridLines="None" DataSourceID="SqlDataSource1" AllowPaging="True" AutoGenerateRows="False"
                        DataKeyNames="userID" AutoGenerateInsertButton="True" DefaultMode="Edit" CssClass="mGrid"
                        PagerStyle-CssClass="pgr" AlternatingRowStyle-CssClass="alt" 
                            OnPageIndexChanging="DetailsView1_PageIndexChanging" 
                            EnableModelValidation="True">
                        <AlternatingRowStyle CssClass="alt"></AlternatingRowStyle>
                        <Fields>

                            <asp:TemplateField HeaderText="General Details" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="userID" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>                           
                                    <asp:Label ID="lbluserID" runat="server" Text='<%# Eval("userID") %>' />
                                </ItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Registration Date" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>   
                                    <asp:Label ID="lblInsertDate" runat="server" Text='<%# Eval("InsertDate")%>' />
                                </ItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Date Converted *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblDateConverted" runat="server" Text='<%# bind("DateConverted")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="DateConverted" runat="server" Text='<%# Bind("DateConverted") %>' onclick="WdatePicker({minDate:'%y-%M-#{%d}'})" ></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Account Status" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblAccountStatus" runat="server" Text='<%# bind("AccountStatus")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AccountStatus" width="18px" readonly="true" runat="server" Text='<%# Bind("AccountStatus") %>'></asp:TextBox>
                                    <asp:TextBox ID="StatusName" runat="server" Text='<%# Bind("StatusName") %>'></asp:TextBox>
                                    <asp:DropDownList name="selAccountStatus" ID="selAccountStatus" runat="Server" DataSourceID="SqlDataSource6"
                                        DataTextField="AccountStatusName" DataValueField="AccountStatusID" SelectedValue='<%# Bind("AccountStatus") %>'
                                        onchange="AccountStatusChanged()">
                                    </asp:DropDownList><br />
                                    <asp:TextBox ID="AccountStatusHistory" Rows="5" cols="40" Width="60%" runat="server"
                                        TextMode="MultiLine" Text='<%# Bind("AccountStatusHistory") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Comments" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                    Add Notes<input type="text" id="addcomments" size="75" />
                                    <asp:TextBox ID="Comments" Rows="5" cols="40" Width="97%" runat="server" TextMode="MultiLine"
                                        Text='<%# Bind("Comments") %>'></asp:TextBox>
                                </EditItemTemplate>
                                <ItemTemplate>
                                    <asp:Label ID="Label3" runat="server" Text='<%# Bind("Comments") %>'></asp:Label>
                                </ItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Preferred Day To Contact" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblPreferredDay" runat="server" Text='<%# bind("PreferredDay")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="PreferredDay" runat="server" onclick="WdatePicker()" Text='<%# Bind("PreferredDay") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Preferred Time To Contact" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="PreferredTime" runat="server" Text='<%# Bind("PreferredTime") %>'></asp:TextBox>                                   
                                    <asp:DropDownList name="selPreferredTime" ID="selPreferredTime" runat="Server" HeaderText="Preferred Time" onchange="PreferredTimeChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="8:00 AM - 9:00 AM">8:00 AM - 9:00 AM</asp:ListItem>
                                        <asp:ListItem Value="9:00 AM - 10:00 AM">9:00 AM - 10:00 AM</asp:ListItem>
                                        <asp:ListItem Value="10:00 AM - 11:00 AM">10:00 AM - 11:00 AM</asp:ListItem>
                                        <asp:ListItem Value="11:00 AM - 12:00 AM">11:00 AM - 12:00 AM</asp:ListItem>
                                        <asp:ListItem Value="12:00 AM - 1:00 PM">12:00 AM - 1:00 PM</asp:ListItem>
                                        <asp:ListItem Value="1:00 PM - 2:00 PM">1:00 PM - 2:00 PM</asp:ListItem>
                                        <asp:ListItem Value="2:00 PM - 3:00 PM">2:00 PM - 3:00 PM</asp:ListItem>
                                        <asp:ListItem Value="3:00 PM - 4:00 PM">3:00 PM - 4:00 PM</asp:ListItem>
                                        <asp:ListItem Value="4:00 PM - 5:00 PM">4:00 PM - 5:00 PM</asp:ListItem>
                                        <asp:ListItem Value="5:00 PM - 6:00 PM">5:00 PM - 6:00 PM</asp:ListItem>
                                        <asp:ListItem Value="6:00 PM - 7:00 PM">6:00 PM - 7:00 PM</asp:ListItem>
                                        <asp:ListItem Value="7:00 PM - 8:00 PM">7:00 PM - 8:00 PM</asp:ListItem>
                                        <asp:ListItem Value="8:00 PM - 9:00 PM">8:00 PM - 9:00 PM</asp:ListItem>
                                    </asp:DropDownList> 
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Golf Club *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="GolfClub" runat="server" Text='<%# Bind("GolfClub") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="G2G Solar *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="G2GSolar" runat="server" Text='<%# Bind("G2G_Solar") %>'></asp:TextBox>
                                <asp:DropDownList name="selG2GSolar" ID="selG2GSolar" runat="Server" HeaderText="G2G Solar" onchange="G2GSolarChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Competition *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="Competition" runat="server" Text='<%# Bind("Competition") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            

                            <asp:TemplateField HeaderText="SSE Operator *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="OperatorSSE" runat="server" Text='<%# Bind("OperatorSSE") %>'></asp:TextBox>
                                    <asp:DropDownList name="selOperatorSSE" ID="selOperatorSSE" runat="Server" HeaderText="Operator SSE" onchange="OperatorSSEChanged()"
                                     DataSourceID="SqlDataSource36" DataTextField="OperatorName" DataValueField="OperatorName" />
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Promotion Code" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblPromotionCode" runat="server" Text='<%# bind("PromotionCode")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="PromotionCode" runat="server" Text='<%# Bind("PromotionCode") %>' visible="true"></asp:TextBox>
                                    <asp:DropDownList name="selPromotionCode" ID="selPromotionCode" runat="Server" DataSourceID="SqlDataSource35"
                                        DataTextField="PromotionCodeName" DataValueField="PromotionCodeName" onchange="PromotionCodeChanged()"> 
                                    </asp:DropDownList>                  
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Lead Source Code" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblLeadSource" runat="server" Text='<%# bind("LeadSource")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="LeadSource" runat="server" Text='<%# Bind("LeadSource") %>' Visible="true"></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Administration Fee" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblAdminFee" runat="server" Text='<%# bind("AdminFee")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AdminFee" runat="server" Text='<%# Bind("AdminFee") %>'></asp:TextBox>
                                    <asp:DropDownList name="selAdminFee" ID="selAdminFee" runat="Server" onchange="AdminFeeChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="0">Free</asp:ListItem>
                                        <asp:ListItem Value="50">$50</asp:ListItem>
                                        <asp:ListItem Value="100">$100</asp:ListItem>
                                        <asp:ListItem Value="200">$200</asp:ListItem>
                                        <asp:ListItem Value="300">$300</asp:ListItem>
                                        <asp:ListItem Value="400">$400</asp:ListItem>
                                        <asp:ListItem Value="500">$500</asp:ListItem>
                                        <asp:ListItem Value="600">$600</asp:ListItem>
                                        <asp:ListItem Value="700">$700</asp:ListItem>
                                        <asp:ListItem Value="800">$800</asp:ListItem>
                                        <asp:ListItem Value="900">$900</asp:ListItem>
                                        <asp:ListItem Value="1000">$1,000</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Vendor ID" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="VendorID" runat="server" Text='<%# Bind("VendorID") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Organisation Type" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblTypeOrg" runat="server" Text='<%# bind("TypeOrg")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TypeOrg" runat="server" Text='<%# Bind("TypeOrg") %>'></asp:TextBox>
                                    <asp:DropDownList name="selTypeOrg" ID="selTypeOrg" runat="Server" HeaderText="Organisation Type" onchange="TypeOrgChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="RESI">RESI</asp:ListItem>
                                        <asp:ListItem Value="SME">SME</asp:ListItem>
                                        <asp:ListItem Value="C&I">C&I</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Customer Details" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="RESI/SME *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="RESI_SME" runat="server" Text='<%# Bind("RESI_SME") %>'></asp:TextBox>
                                    <asp:DropDownList name="selRESI_SME" ID="selRESI_SME" runat="Server" HeaderText="RESI/SME" onchange="RESI_SME_Changed()" Visible="false">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="RESI">RESI</asp:ListItem>
                                        <asp:ListItem Value="SME">SME</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Company Name *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblCompanyName" runat="server" Text='<%# bind("CompanyName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CompanyName" runat="server" Text='<%# Bind("CompanyName") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Company ABN *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblCompanyABN" runat="server" Text='<%# bind("CompanyABN")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CompanyABN" runat="server" Text='<%# Bind("CompanyABN") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Name" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblFirstName" runat="server" Text='<%# bind("FirstName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="FirstName" runat="server" Text='<%# Bind("FirstName") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Last Name" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblLastName" runat="server" Text='<%# bind("LastName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="LastName" runat="server" Text='<%# Bind("LastName") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Account Holder Title *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="FirstAccountHolderTitle" runat="server" Text='<%# Bind("FirstAccountHolderTitle") %>'></asp:TextBox>
                                    <asp:DropDownList name="selFirstAccountHolderTitle" ID="selFirstAccountHolderTitle" runat="Server" HeaderText="First Account Holder Title" onchange="FirstAccountHolderTitleChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Mr">Mr</asp:ListItem>
                                        <asp:ListItem Value="Miss">Miss</asp:ListItem>
                                        <asp:ListItem Value="Mrs">Mrs</asp:ListItem>
                                        <asp:ListItem Value="Ms">Ms</asp:ListItem>
                                        <asp:ListItem Value="Dr">Dr</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Account Holder First Name *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblFirstAccountHolderFirstName" runat="server" Text='<%# bind("FirstAccountHolderFirstName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="FirstAccountHolderFirstName" runat="server" Text='<%# Bind("FirstAccountHolderFirstName") %>'></asp:TextBox>
                                    <input type="button" ID="CopyName" runat="server" value="Copy Name" onclick="CopyNameClick()"/>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Account Holder Surname *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblFirstAccountHolderSurname" runat="server" Text='<%# bind("FirstAccountHolderSurname")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="FirstAccountHolderSurname" runat="server" Text='<%# Bind("FirstAccountHolderSurname") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="First Account Holder DOB *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblFirstAccountHolderDOB" runat="server" Text='<%# bind("FirstAccountHolderDOB")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="FirstAccountHolderDOB" runat="server" onclick="WdatePicker({maxDate:'1994-12-30'})"  Text='<%# Bind("FirstAccountHolderDOB") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Street" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblStreet" runat="server" Text='<%# bind("Street")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Street" runat="server" Text='<%# Bind("Street") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Suburb" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSuburb" runat="server" Text='<%# bind("Suburb")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Suburb" runat="server" Text='<%# Bind("Suburb") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="State" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                    <asp:TextBox ID="StateName" runat="server" Text='<%# Bind("StateName") %>'></asp:TextBox>    
                                    <asp:DropDownList name="selStateName" ID="selStateName" runat="Server" HeaderText="StateName" onchange="StateNameChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="ACT">ACT</asp:ListItem>
                                        <asp:ListItem Value="NSW">NSW</asp:ListItem>
                                        <asp:ListItem Value="NT">NT</asp:ListItem>
                                        <asp:ListItem Value="QLD">QLD</asp:ListItem>
                                        <asp:ListItem Value="SA">SA</asp:ListItem>
                                        <asp:ListItem Value="TAS">TAS</asp:ListItem>
                                        <asp:ListItem Value="VIC">VIC</asp:ListItem>
                                        <asp:ListItem Value="WA">WA</asp:ListItem>                     
                                    </asp:DropDownList>               
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Postcode" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblPostcode" runat="server" Text='<%# bind("Postcode")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Postcode" runat="server" Text='<%# Bind("Postcode") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Email *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblEmail" runat="server" Text='<%# bind("Email")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Email" runat="server" Text='<%# Bind("Email") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>                          
                            
                            <asp:TemplateField HeaderText="Contact Tel *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblPhone" runat="server" Text='<%# bind("Phone")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Phone" runat="server" Text='<%# Bind("Phone") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            <asp:TemplateField HeaderText="Second Tel" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblMobile" runat="server" Text='<%# bind("Mobile")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="Mobile" runat="server" Text='<%# Bind("Mobile") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
   
                                <asp:TemplateField HeaderText="Contact Tel *" Visible="false" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblContactTel" runat="server" Text='<%# bind("ContactTel")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ContactTel" runat="server" Text='<%# Bind("ContactTel") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Tel" Visible="false" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSecondTel" runat="server" Text='<%# bind("SecondTel")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SecondTel" runat="server" Text='<%# Bind("SecondTel") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="ID Type *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="ID_Type" runat="server" Text='<%# Bind("ID_Type") %>'></asp:TextBox>
                                    <asp:DropDownList name="selID_Type" ID="selID_Type" runat="Server" HeaderText="ID Type" onchange="ID_TypeChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="PASSPORT">PASSPORT</asp:ListItem>
                                        <asp:ListItem Value="MEDICARE">MEDICARE</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE ACT">DRIVING LICENSE ACT</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE NSW">DRIVING LICENSE NSW</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE NT">DRIVING LICENSE NT</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE QLD">DRIVING LICENSE QLD</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE SA">DRIVING LICENSE SA</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE TAS">DRIVING LICENSE TAS</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE VIC">DRIVING LICENSE VIC</asp:ListItem>
                                        <asp:ListItem Value="DRIVING LICENSE WA">DRIVING LICENSE WA</asp:ListItem>                     
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="ID Number *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblID_Number" runat="server" Text='<%# bind("ID_Number")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ID_Number" runat="server" Text='<%# Bind("ID_Number") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="ID Expiry" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblID_Expiry" runat="server" Text='<%# bind("ID_Expiry")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ID_Expiry" runat="server" onclick="WdatePicker()" Text='<%# Bind("ID_Expiry") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Account Holder?" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                    <asp:DropDownList name="selSecondAccountHolder" ID="selSecondAccountHolder" runat="Server" HeaderText="Second Account Holder?" onchange="SecondAccountHolderChanged()">
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Account Holder Title" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="SecondAccountHolderTitle" runat="server" Text='<%# Bind("SecondAccountHolderTitle") %>'></asp:TextBox>
                                    <asp:DropDownList name="selSecondAccountHolderTitle" ID="selSecondAccountHolderTitle" runat="Server" HeaderText="Second Account Holder Title" onchange="SecondAccountHolderTitleChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Mr">Mr</asp:ListItem>
                                        <asp:ListItem Value="Miss">Miss</asp:ListItem>
                                        <asp:ListItem Value="Mrs">Mrs</asp:ListItem>
                                        <asp:ListItem Value="Ms">Ms</asp:ListItem>
                                        <asp:ListItem Value="Dr">Dr</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            
                            <asp:TemplateField HeaderText="Second Account Holder First Name" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSecondAccountHolderFirstName" runat="server" Text='<%# bind("SecondAccountHolderFirstName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SecondAccountHolderFirstName" runat="server" Text='<%# Bind("SecondAccountHolderFirstName") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Account Holder Surname" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSecondAccountHolderSurname" runat="server" Text='<%# bind("SecondAccountHolderSurname")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SecondAccountHolderSurname" runat="server" Text='<%# Bind("SecondAccountHolderSurname") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Second Account Holder DOB" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblSecondAccountHolderDOB" runat="server" Text='<%# bind("SecondAccountHolderDOB")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SecondAccountHolderDOB" runat="server" onclick="WdatePicker({maxDate:'1994-12-30'})" Text='<%# Bind("SecondAccountHolderDOB") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card?" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                    <asp:DropDownList name="selConcessionCard" ID="selConcessionCard" runat="Server" HeaderText="Concession Card?" onchange="ConcessionCardChanged()">
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card Type" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="ConcessionCardType" runat="server" Text='<%# Bind("ConcessionCardType") %>'></asp:TextBox>
                                    <asp:DropDownList name="selConcessionCardType" ID="selConcessionCardType" runat="Server" HeaderText="Concession Card Type" onchange="ConcessionCardTypeChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Pensioner">Pensioner</asp:ListItem>
                                        <asp:ListItem Value="Govt Building">Govt Building</asp:ListItem>
                                        <asp:ListItem Value="Seniors Card">Seniors Card</asp:ListItem>
                                        <asp:ListItem Value="Other">Other</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card Entitlement" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblConcessionCardEntitlement" runat="server" Text='<%# bind("ConcessionCardEntitlement")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ConcessionCardEntitlement" runat="server" Text='<%# Bind("ConcessionCardEntitlement") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card Number" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblConcessionCardNo" runat="server" Text='<%# bind("ConcessionCardNo")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ConcessionCardNo" runat="server" Text='<%# Bind("ConcessionCardNo") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Concession Card Expiry" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblConcessionCardExp" runat="server" Text='<%# bind("ConcessionCardExp")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ConcessionCardExp" runat="server" onclick="WdatePicker()" Text='<%# Bind("ConcessionCardExp") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Name On Concession Card" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblNameOnConcessionCard" runat="server" Text='<%# bind("NameOnConcessionCard")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="NameOnConcessionCard" runat="server" Text='<%# Bind("NameOnConcessionCard") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Electricity Conversion *" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ElectricityConversion" runat="server" Text='<%# Bind("ElectricityConversion") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElectricityConversion" ID="selElectricityConversion" runat="Server" HeaderText="Electricity Conversion" onchange="ElectricityConversionChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Elec? *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="Elec" runat="server" Text='<%# Bind("Elec") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElec" ID="selElec" runat="Server" HeaderText="Elec" onchange="ElecChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="NMI *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblNMI" runat="server" Text='<%# bind("NMI")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="NMI" runat="server" Text='<%# Bind("NMI") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Electricity Month/Quarter" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ElecMonthQuarter" runat="server" Text='<%# Bind("ElecMonthQuarter") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElecMonthQuarter" ID="selElecMonthQuarter" runat="Server" onchange="ElecMonthQuarterChanged()" HeaderText="Electricity Month/Quarter">
									    <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Month">Month</asp:ListItem>
                                        <asp:ListItem Value="Quarter">Quarter</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Electricity Monthly/Quarterly Spend" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ElecMonthQuarterSpend" runat="server" Text='<%# Bind("ElecMonthQuarterSpend") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElecSpend" ID="selElecSpend" runat="Server"
                                        onchange="ElecSpendChanged()" HeaderText="Electricity Monthly/Quarterly Spend">
                                        <asp:ListItem Value="0">Select...</asp:ListItem>
                                        <asp:ListItem Value="50">$50</asp:ListItem>
                                        <asp:ListItem Value="100">$100</asp:ListItem>
                                        <asp:ListItem Value="150">$150</asp:ListItem>
                                        <asp:ListItem Value="200">$200</asp:ListItem>
                                        <asp:ListItem Value="250">$250</asp:ListItem>
                                        <asp:ListItem Value="300">$300</asp:ListItem>
                                        <asp:ListItem Value="350">$350</asp:ListItem>
                                        <asp:ListItem Value="400">$400</asp:ListItem>
                                        <asp:ListItem Value="450">$450</asp:ListItem>
                                        <asp:ListItem Value="500">$500</asp:ListItem>
                                        <asp:ListItem Value="550">$550</asp:ListItem>
                                        <asp:ListItem Value="600">$600</asp:ListItem>
                                        <asp:ListItem Value="650">$650</asp:ListItem>
                                        <asp:ListItem Value="700">$700</asp:ListItem>
                                        <asp:ListItem Value="750">$750</asp:ListItem>
                                        <asp:ListItem Value="800">$800</asp:ListItem>
                                        <asp:ListItem Value="850">$850</asp:ListItem>
                                        <asp:ListItem Value="900">$900</asp:ListItem>
                                        <asp:ListItem Value="950">$950</asp:ListItem>
                                        <asp:ListItem Value="1000">$1,000</asp:ListItem>
                                        <asp:ListItem Value="1500">$1,500</asp:ListItem>
                                        <asp:ListItem Value="2000">$2,000</asp:ListItem>
                                        <asp:ListItem Value="2500">$2,500</asp:ListItem>
                                        <asp:ListItem Value="3000">$3,000</asp:ListItem>
                                        <asp:ListItem Value="3500">$3,500</asp:ListItem>
                                        <asp:ListItem Value="4000">$4,000</asp:ListItem>
                                        <asp:ListItem Value="4500">$4,500</asp:ListItem>
                                        <asp:ListItem Value="5000">$5,000</asp:ListItem>
                                        <asp:ListItem Value="5500">$5,500</asp:ListItem>
                                        <asp:ListItem Value="6000">$6,000</asp:ListItem>
                                        <asp:ListItem Value="6500">$6,500</asp:ListItem>
                                        <asp:ListItem Value="7000">$7,000</asp:ListItem>
                                        <asp:ListItem Value="7500">$7,500</asp:ListItem>
                                        <asp:ListItem Value="8000">$8,000</asp:ListItem>
                                        <asp:ListItem Value="8500">$8,500</asp:ListItem>
                                        <asp:ListItem Value="9000">$9,000</asp:ListItem>
                                        <asp:ListItem Value="9500">$9,500</asp:ListItem>
                                        <asp:ListItem Value="10000">$10,000</asp:ListItem>
                                        <asp:ListItem Value="15000">$15,000</asp:ListItem>
                                        <asp:ListItem Value="20000">$20,000</asp:ListItem>
                                        <asp:ListItem Value="25000">$25,000</asp:ListItem>
                                        <asp:ListItem Value="30000">$30,000</asp:ListItem>
                                        <asp:ListItem Value="35000">$35,000</asp:ListItem>
                                        <asp:ListItem Value="40000">$40,000</asp:ListItem>
                                        <asp:ListItem Value="45000">$45,000</asp:ListItem>
                                        <asp:ListItem Value="50000">$50,000</asp:ListItem>
                                        <asp:ListItem Value="55000">$55,000</asp:ListItem>
                                        <asp:ListItem Value="60000">$60,000</asp:ListItem>
                                        <asp:ListItem Value="65000">$65,000</asp:ListItem>
                                        <asp:ListItem Value="70000">$70,000</asp:ListItem>
                                        <asp:ListItem Value="75000">$75,000</asp:ListItem>
                                        <asp:ListItem Value="80000">$80,000</asp:ListItem>
                                        <asp:ListItem Value="85000">$85,000</asp:ListItem>
                                        <asp:ListItem Value="90000">$90,000</asp:ListItem>
                                        <asp:ListItem Value="95000">$95,000</asp:ListItem>
                                        <asp:ListItem Value="100000">$100,000</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Electricity Annual Spend *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblElecTotalAnnualSpend" runat="server" Text='<%# bind("ElecTotalAnnualSpend")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="ElecTotalAnnualSpend" runat="server" Text='<%# Bind("ElecTotalAnnualSpend") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Conversion *" HeaderStyle-Font-Size="Large"  HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="GasConversion" runat="server" Text='<%# Bind("GasConversion") %>'></asp:TextBox>
                                    <asp:DropDownList name="selGasConversion" ID="selGasConversion" runat="Server" HeaderText="Gas Conversion" onchange="GasConversionChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas? *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="Gas" runat="server" Text='<%# Bind("Gas") %>'></asp:TextBox>
                                    <asp:DropDownList name="selGas" ID="selGas" runat="Server" HeaderText="Gas" onchange="GasChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="MIRN *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblMIRN" runat="server" Text='<%# bind("MIRN")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="MIRN" runat="server" Text='<%# Bind("MIRN") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Month/Quarter" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="GasMonthQuarter" runat="server" Text='<%# Bind("GasMonthQuarter") %>'></asp:TextBox>			
                                    <asp:DropDownList name="selGasMonthQuarter" ID="selGasMonthQuarter" runat="Server" onchange="GasMonthQuarterChanged()" HeaderText="Gas Month/Quarter">
										<asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Month">Month</asp:ListItem>
                                        <asp:ListItem Value="Quarter">Quarter</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Monthly/Quarterly Spend" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="GasMonthQuarterSpend" runat="server" Text='<%# Bind("GasMonthQuarterSpend") %>'></asp:TextBox>	
                                    <asp:DropDownList name="selGasSpend" ID="selGasSpend" runat="Server"
                                        onchange="GasSpendChanged()" HeaderText="Gas Monthly/Quarterly Spend">
                                        <asp:ListItem Value="0">Select...</asp:ListItem>
                                        <asp:ListItem Value="50">$50</asp:ListItem>
                                        <asp:ListItem Value="100">$100</asp:ListItem>
                                        <asp:ListItem Value="150">$150</asp:ListItem>
                                        <asp:ListItem Value="200">$200</asp:ListItem>
                                        <asp:ListItem Value="250">$250</asp:ListItem>
                                        <asp:ListItem Value="300">$300</asp:ListItem>
                                        <asp:ListItem Value="350">$350</asp:ListItem>
                                        <asp:ListItem Value="400">$400</asp:ListItem>
                                        <asp:ListItem Value="450">$450</asp:ListItem>
                                        <asp:ListItem Value="500">$500</asp:ListItem>
                                        <asp:ListItem Value="550">$550</asp:ListItem>
                                        <asp:ListItem Value="600">$600</asp:ListItem>
                                        <asp:ListItem Value="650">$650</asp:ListItem>
                                        <asp:ListItem Value="700">$700</asp:ListItem>
                                        <asp:ListItem Value="750">$750</asp:ListItem>
                                        <asp:ListItem Value="800">$800</asp:ListItem>
                                        <asp:ListItem Value="850">$850</asp:ListItem>
                                        <asp:ListItem Value="900">$900</asp:ListItem>
                                        <asp:ListItem Value="950">$950</asp:ListItem>
                                        <asp:ListItem Value="1000">$1,000</asp:ListItem>
                                        <asp:ListItem Value="1500">$1,500</asp:ListItem>
                                        <asp:ListItem Value="2000">$2,000</asp:ListItem>
                                        <asp:ListItem Value="2500">$2,500</asp:ListItem>
                                        <asp:ListItem Value="3000">$3,000</asp:ListItem>
                                        <asp:ListItem Value="3500">$3,500</asp:ListItem>
                                        <asp:ListItem Value="4000">$4,000</asp:ListItem>
                                        <asp:ListItem Value="4500">$4,500</asp:ListItem>
                                        <asp:ListItem Value="5000">$5,000</asp:ListItem>
                                        <asp:ListItem Value="5500">$5,500</asp:ListItem>
                                        <asp:ListItem Value="6000">$6,000</asp:ListItem>
                                        <asp:ListItem Value="6500">$6,500</asp:ListItem>
                                        <asp:ListItem Value="7000">$7,000</asp:ListItem>
                                        <asp:ListItem Value="7500">$7,500</asp:ListItem>
                                        <asp:ListItem Value="8000">$8,000</asp:ListItem>
                                        <asp:ListItem Value="8500">$8,500</asp:ListItem>
                                        <asp:ListItem Value="9000">$9,000</asp:ListItem>
                                        <asp:ListItem Value="9500">$9,500</asp:ListItem>
                                        <asp:ListItem Value="10000">$10,000</asp:ListItem>
                                        <asp:ListItem Value="15000">$15,000</asp:ListItem>
                                        <asp:ListItem Value="20000">$20,000</asp:ListItem>
                                        <asp:ListItem Value="25000">$25,000</asp:ListItem>
                                        <asp:ListItem Value="30000">$30,000</asp:ListItem>
                                        <asp:ListItem Value="35000">$35,000</asp:ListItem>
                                        <asp:ListItem Value="40000">$40,000</asp:ListItem>
                                        <asp:ListItem Value="45000">$45,000</asp:ListItem>
                                        <asp:ListItem Value="50000">$50,000</asp:ListItem>
                                        <asp:ListItem Value="55000">$55,000</asp:ListItem>
                                        <asp:ListItem Value="60000">$60,000</asp:ListItem>
                                        <asp:ListItem Value="65000">$65,000</asp:ListItem>
                                        <asp:ListItem Value="70000">$70,000</asp:ListItem>
                                        <asp:ListItem Value="75000">$75,000</asp:ListItem>
                                        <asp:ListItem Value="80000">$80,000</asp:ListItem>
                                        <asp:ListItem Value="85000">$85,000</asp:ListItem>
                                        <asp:ListItem Value="90000">$90,000</asp:ListItem>
                                        <asp:ListItem Value="95000">$95,000</asp:ListItem>
                                        <asp:ListItem Value="100000">$100,000</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Annual Spend *" HeaderStyle-BackColor="#CCFFCC" ItemStyle-BackColor="#CCFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblGasTotalAnnualSpend" runat="server" Text='<%# bind("GasTotalAnnualSpend")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="GasTotalAnnualSpend" runat="server" Text='<%# Bind("GasTotalAnnualSpend") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Product Information" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Total Annual Spend" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblTotalAnnualSpend" runat="server" Text='<%# bind("TotalAnnualSpend")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="TotalAnnualSpend" runat="server" Text='<%# Bind("TotalAnnualSpend") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Current Provider" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblcurrprovider" runat="server" Text='<%# bind("CurrentProvider")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="CurrentProvider" runat="server" Text='<%# Bind("CurrentProvider") %>'></asp:TextBox>
                                    <asp:DropDownList name="selCurrentProvider" id="selCurrentProvider" DataSourceID="SqlDataSource37"
                                        DataTextField="CurrentProviderName" DataValueField="CurrentProviderName" onchange="CurrentProviderChanged()" runat="server"/>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="New Provider" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <ItemTemplate>
                                    <asp:Label ID="lblRetailerName" runat="server" Text='<%# bind("ProviderID")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:HiddenField ID="ProviderID" runat="server" Value='<%# Bind("ProviderID") %>'>
                                    </asp:HiddenField>
                                    <asp:DropDownList name="selProviderID" ID="selProviderID" runat="Server">
                                    <asp:ListItem Value="TRUenergy ">TRUenergy</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Source Code *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="SourceCode" runat="server" Text='<%# Bind("SourceCode") %>'></asp:TextBox>                                   
                                    <asp:DropDownList name="selSourceCode" ID="selSourceCode" runat="Server" HeaderText="Source Code" onchange="SourceCodeChanged()" Visible="false">
                                        <asp:ListItem Value="">Select...</asp:ListItem>       
                                        <asp:ListItem Value="STREETSMART_EDGE_14%VD_REB">STREETSMART_EDGE_14%VD_REB</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_12%VD_REB">STREETSMART_EDGE_12%VD_REB</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_17%VD‏">STREETSMART_EDGE_17%VD‏</asp:ListItem>
										<asp:ListItem Value="STREETSMART_EDGE_14%VD">STREETSMART_EDGE_14%VD</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_12%VD">STREETSMART_EDGE_12%VD</asp:ListItem>
                                        <asp:ListItem Value="STREETSMART_EDGE_10%VD">STREETSMART_EDGE_10%VD</asp:ListItem>                                       
                                        <asp:ListItem Value="STREETSMART_7%PDD">STREETSMART_7%PDD</asp:ListItem>
										<asp:ListItem Value="STREETSMART_5%PDD">STREETSMART_5%PDD</asp:ListItem> 
                                        <asp:ListItem Value="STREETSMART_RES">STREETSMART_RES</asp:ListItem>
										<asp:ListItem Value="GROUPBUY_9%PDD">GROUPBUY_9%PDD</asp:ListItem>
                                        <asp:ListItem Value="BULKRES_OFFER3">BULKRES_OFFER3</asp:ListItem>
                                        <asp:ListItem Value="EXEL_8%PDD">EXEL_8%PDD</asp:ListItem>
                                    </asp:DropDownList> 
                                    <asp:DropDownList name="selSourceCodeRESI" ID="selSourceCodeRESI" runat="Server" HeaderText="Source Code" onchange="SourceCodeRESIChanged()" 
                                    DataSourceID="SqlDataSource4" DataTextField="SourceCodeRESI_Name" DataValueField="SourceCodeRESI_Name"  />        
                                    <asp:DropDownList name="selSourceCodeSME" ID="selSourceCodeSME" runat="Server" HeaderText="Source Code" onchange="SourceCodeSMEChanged()"
                                    DataSourceID="SqlDataSource5" DataTextField="SourceCodeSME_Name" DataValueField="SourceCodeSME_Name" />                                     
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Product Type *" HeaderStyle-BackColor="#FFFFCC" ItemStyle-BackColor="#FFFFCC">
                                <EditItemTemplate>
                                <asp:TextBox ID="ProductType" runat="server" Text='<%# Bind("ProductType") %>'></asp:TextBox>
                                    <asp:DropDownList name="selProductType" ID="selProductType" runat="Server" HeaderText="Product Type" onchange="ProductTypeChanged()" Visible="false">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="PEAK_ONLY">PEAK_ONLY</asp:ListItem>
                                        <asp:ListItem Value="OFF_PEAK">OFF_PEAK</asp:ListItem>
                                        <asp:ListItem Value="PEAK/OFF_PEAK">PEAK/OFF_PEAK</asp:ListItem>
                                        <asp:ListItem Value="TOU">TOU</asp:ListItem>
                                        <asp:ListItem Value="BUSINESSEDGE">BUSINESSEDGE</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE">GOFORMORE</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_PEAKONLY">BUSEDGE_PEAKONLY</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_OFFPEAK">BUSEDGE_OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_PEAK/OFFPEAK">BUSEDGE_PEAK/OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="BUSEDGE_TOU">BUSEDGE_TOU</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_PEAKONLY">GOFORMORE_PEAKONLY</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_OFFPEAK">GOFORMORE_OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_PEAK/OFFPEAK">GOFORMORE_PEAK/OFFPEAK</asp:ListItem>
                                        <asp:ListItem Value="GOFORMORE_TOU">GOFORMORE_TOU</asp:ListItem>  										
                                    </asp:DropDownList>
                                    <asp:DropDownList name="selProductTypeRESI" ID="selProductTypeRESI" runat="Server" HeaderText="Product Type" onchange="ProductTypeRESIChanged()"
                                    DataSourceID="SqlDataSource7" DataTextField="ProductTypeRESI_Name" DataValueField="ProductTypeRESI_Name" />  										
                                    <asp:DropDownList name="selProductTypeSME" ID="selProductTypeSME" runat="Server" HeaderText="Product Type" onchange="ProductTypeSMEChanged()" 
                                    DataSourceID="SqlDataSource8" DataTextField="ProductTypeSME_Name" DataValueField="ProductTypeSME_Name"/>									
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Property Details" HeaderStyle-Font-Size="Large" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Mover/Switcher *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="MoverSwicher" runat="server" Text='<%# Bind("MoverSwicher") %>'></asp:TextBox>
                                    <asp:DropDownList name="selMoverSwicher" ID="selMoverSwicher" runat="Server" HeaderText="Mover/Switcher" onchange="MoverSwicherChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Mover">Mover</asp:ListItem>
                                        <asp:ListItem Value="Switcher">Switcher</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Move In Date *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblMoveInDate" runat="server" Text='<%# bind("MoveInDate")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="MoveInDate" runat="server" onclick="WdatePicker()" Text='<%# Bind("MoveInDate") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Supply Address *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSupplyAddress" runat="server" Text='<%# bind("SupplyAddress")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SupplyAddress" runat="server" Text='<%# Bind("SupplyAddress") %>'></asp:TextBox>
                                    <input type="button" ID="CopyAddress" runat="server" value="Copy Address" onclick="CopyAddressClick()"/>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Supply Address Suburb *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSupplyAddressSuburb" runat="server" Text='<%# bind("SupplyAddressSuburb")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SupplyAddressSuburb" runat="server" Text='<%# Bind("SupplyAddressSuburb") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Supply Address State *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="SupplyAddressState" runat="server" Text='<%# Bind("SupplyAddressState") %>'></asp:TextBox>
                                    <asp:DropDownList name="selSupplyAddressState" ID="selSupplyAddressState" runat="Server" HeaderText="Supply Address State" onchange="SupplyAddressStateChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="ACT">ACT</asp:ListItem>
                                        <asp:ListItem Value="NSW">NSW</asp:ListItem>
                                        <asp:ListItem Value="NT">NT</asp:ListItem>
                                        <asp:ListItem Value="QLD">QLD</asp:ListItem>
                                        <asp:ListItem Value="SA">SA</asp:ListItem>
                                        <asp:ListItem Value="TAS">TAS</asp:ListItem>
                                        <asp:ListItem Value="VIC">VIC</asp:ListItem>
                                        <asp:ListItem Value="WA">WA</asp:ListItem>                     
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Supply Address Postcode *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSupplyAddressPostcode" runat="server" Text='<%# bind("SupplyAddressPostcode")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SupplyAddressPostcode" runat="server" Text='<%# Bind("SupplyAddressPostcode") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Total Sites" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="TotalSites" runat="server" Text='<%# Bind("TotalSites") %>'></asp:TextBox>
                                    <asp:DropDownList name="selTotalSites" ID="selTotalSites" runat="Server" HeaderText="Total Sites"  onchange="TotalSitesChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="1">1</asp:ListItem>
                                        <asp:ListItem Value="2">2</asp:ListItem>
                                        <asp:ListItem Value="3">3</asp:ListItem>
                                        <asp:ListItem Value="4">4</asp:ListItem>
                                        <asp:ListItem Value="5">5</asp:ListItem>
                                        <asp:ListItem Value="6">6</asp:ListItem>
                                        <asp:ListItem Value="7">7</asp:ListItem>
                                        <asp:ListItem Value="8">8</asp:ListItem>
                                        <asp:ListItem Value="9">9</asp:ListItem>
                                        <asp:ListItem Value="10">10</asp:ListItem>
                                        <asp:ListItem Value="11">11</asp:ListItem>
                                        <asp:ListItem Value="12">12</asp:ListItem>
                                        <asp:ListItem Value="13">13</asp:ListItem>
                                        <asp:ListItem Value="14">14</asp:ListItem>
                                        <asp:ListItem Value="15">15</asp:ListItem>
                                        <asp:ListItem Value="16">16</asp:ListItem>
                                        <asp:ListItem Value="17">17</asp:ListItem>
                                        <asp:ListItem Value="18">18</asp:ListItem>
                                        <asp:ListItem Value="19">19</asp:ListItem>
                                        <asp:ListItem Value="20">20</asp:ListItem>
                                        <asp:ListItem Value="21">21</asp:ListItem>
                                        <asp:ListItem Value="22">22</asp:ListItem>
                                        <asp:ListItem Value="23">23</asp:ListItem>
                                        <asp:ListItem Value="24">24</asp:ListItem>
                                        <asp:ListItem Value="25">25</asp:ListItem>
                                        <asp:ListItem Value="26">26</asp:ListItem>
                                        <asp:ListItem Value="27">27</asp:ListItem>
                                        <asp:ListItem Value="28">28</asp:ListItem>
                                        <asp:ListItem Value="29">29</asp:ListItem>
                                        <asp:ListItem Value="30">30</asp:ListItem>
                                        <asp:ListItem Value="31">31</asp:ListItem>
                                        <asp:ListItem Value="32">32</asp:ListItem>
                                        <asp:ListItem Value="33">33</asp:ListItem>
                                        <asp:ListItem Value="34">34</asp:ListItem>
                                        <asp:ListItem Value="35">35</asp:ListItem>
                                        <asp:ListItem Value="36">36</asp:ListItem>
                                        <asp:ListItem Value="37">37</asp:ListItem>
                                        <asp:ListItem Value="38">38</asp:ListItem>
                                        <asp:ListItem Value="39">39</asp:ListItem>
                                        <asp:ListItem Value="40">40</asp:ListItem>
                                        <asp:ListItem Value="41">41</asp:ListItem>
                                        <asp:ListItem Value="42">42</asp:ListItem>
                                        <asp:ListItem Value="43">43</asp:ListItem>
                                        <asp:ListItem Value="44">44</asp:ListItem>
                                        <asp:ListItem Value="45">45</asp:ListItem>
                                        <asp:ListItem Value="46">46</asp:ListItem>
                                        <asp:ListItem Value="47">47</asp:ListItem>
                                        <asp:ListItem Value="48">48</asp:ListItem>
                                        <asp:ListItem Value="49">49</asp:ListItem>
                                        <asp:ListItem Value="50">50</asp:ListItem>
                                        <asp:ListItem Value="60">60</asp:ListItem>
                                        <asp:ListItem Value="70">70</asp:ListItem>
                                        <asp:ListItem Value="80">80</asp:ListItem>
                                        <asp:ListItem Value="90">90</asp:ListItem>
                                        <asp:ListItem Value="100">100</asp:ListItem>
                                        <asp:ListItem Value="120">120</asp:ListItem>
                                        <asp:ListItem Value="140">140</asp:ListItem>
                                        <asp:ListItem Value="160">160</asp:ListItem>
                                        <asp:ListItem Value="180">180</asp:ListItem>
                                        <asp:ListItem Value="200">200</asp:ListItem>
                                        <asp:ListItem Value="220">220</asp:ListItem>
                                        <asp:ListItem Value="240">240</asp:ListItem>
                                        <asp:ListItem Value="250">250</asp:ListItem>
                                        <asp:ListItem Value="260">260</asp:ListItem>
                                        <asp:ListItem Value="280">280</asp:ListItem>
                                        <asp:ListItem Value="300">300</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Tenant/Owner *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="TenantOwner" runat="server" Text='<%# Bind("TenantOwner") %>'></asp:TextBox>
                                    <asp:DropDownList name="selTenantOwner" ID="selTenantOwner" runat="Server" HeaderText="Tenant/Owner" onchange="TenantOwnerChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Tenant">Tenant</asp:ListItem>
                                        <asp:ListItem Value="Owner">Owner</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Number Of People In House" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="NoOfPeopleInHouse" runat="server" Text='<%# Bind("NoOfPeopleInHouse") %>'></asp:TextBox>
                                    <asp:DropDownList name="selNoOfPeopleInHouse" ID="selNoOfPeopleInHouse" runat="Server" HeaderText="No Of People In House" onchange="NoOfPeopleInHouseChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="1">1</asp:ListItem>
                                        <asp:ListItem Value="2">2</asp:ListItem>
                                        <asp:ListItem Value="3">3</asp:ListItem>
                                        <asp:ListItem Value="4">4</asp:ListItem>
                                        <asp:ListItem Value="5">5</asp:ListItem>
                                        <asp:ListItem Value="6">6</asp:ListItem>
                                        <asp:ListItem Value="7">7</asp:ListItem>
                                        <asp:ListItem Value="8">8</asp:ListItem>
                                        <asp:ListItem Value="9">9</asp:ListItem>
                                        <asp:ListItem Value="10">10</asp:ListItem>
                                        <asp:ListItem Value="11">11</asp:ListItem>
                                        <asp:ListItem Value="12">12</asp:ListItem>
                                        <asp:ListItem Value="13">13</asp:ListItem>
                                        <asp:ListItem Value="14">14</asp:ListItem>
                                        <asp:ListItem Value="15">15</asp:ListItem>
                                        <asp:ListItem Value="16">16</asp:ListItem>
                                        <asp:ListItem Value="17">17</asp:ListItem>
                                        <asp:ListItem Value="18">18</asp:ListItem>
                                        <asp:ListItem Value="19">19</asp:ListItem>
                                        <asp:ListItem Value="20">20</asp:ListItem>
                                        <asp:ListItem Value="21">21</asp:ListItem>
                                        <asp:ListItem Value="22">22</asp:ListItem>
                                        <asp:ListItem Value="23">23</asp:ListItem>
                                        <asp:ListItem Value="24">24</asp:ListItem>
                                        <asp:ListItem Value="25">25</asp:ListItem>
                                        <asp:ListItem Value="26">26</asp:ListItem>
                                        <asp:ListItem Value="27">27</asp:ListItem>
                                        <asp:ListItem Value="28">28</asp:ListItem>
                                        <asp:ListItem Value="29">29</asp:ListItem>
                                        <asp:ListItem Value="30">30</asp:ListItem>
                                        <asp:ListItem Value="31">31</asp:ListItem>
                                        <asp:ListItem Value="32">32</asp:ListItem>
                                        <asp:ListItem Value="33">33</asp:ListItem>
                                        <asp:ListItem Value="34">34</asp:ListItem>
                                        <asp:ListItem Value="35">35</asp:ListItem>
                                        <asp:ListItem Value="36">36</asp:ListItem>
                                        <asp:ListItem Value="37">37</asp:ListItem>
                                        <asp:ListItem Value="38">38</asp:ListItem>
                                        <asp:ListItem Value="39">39</asp:ListItem>
                                        <asp:ListItem Value="40">40</asp:ListItem>
                                        <asp:ListItem Value="41">41</asp:ListItem>
                                        <asp:ListItem Value="42">42</asp:ListItem>
                                        <asp:ListItem Value="43">43</asp:ListItem>
                                        <asp:ListItem Value="44">44</asp:ListItem>
                                        <asp:ListItem Value="45">45</asp:ListItem>
                                        <asp:ListItem Value="46">46</asp:ListItem>
                                        <asp:ListItem Value="47">47</asp:ListItem>
                                        <asp:ListItem Value="48">48</asp:ListItem>
                                        <asp:ListItem Value="49">49</asp:ListItem>
                                        <asp:ListItem Value="50">50</asp:ListItem>
                                        <asp:ListItem Value="60">60</asp:ListItem>
                                        <asp:ListItem Value="70">70</asp:ListItem>
                                        <asp:ListItem Value="80">80</asp:ListItem>
                                        <asp:ListItem Value="90">90</asp:ListItem>
                                        <asp:ListItem Value="100">100</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>
                         
                            <asp:TemplateField HeaderText="Any Hazards?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblAnyHazards" runat="server" Text='<%# bind("AnyHazards")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AnyHazards" runat="server" TextMode="MultiLine" Text='<%# Bind("AnyHazards") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Any Access Requirements?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblAnyAccessRequirements" runat="server" Text='<%# bind("AnyAccessRequirements")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AnyAccessRequirements" runat="server" TextMode="MultiLine" Text='<%# Bind("AnyAccessRequirements") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Special Instructions For Access?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSpecialInstructionsForAccess" runat="server" Text='<%# bind("SpecialInstructionsForAccess")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SpecialInstructionsForAccess" runat="server" TextMode="MultiLine" Text='<%# Bind("SpecialInstructionsForAccess") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Advised Main Switch Needs Turning Off?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="AdvisedMainSwitchNeedsTurningOff" runat="server" Text='<%# Bind("AdvisedMainSwitchNeedsTurningOff") %>'></asp:TextBox>
                                    <asp:DropDownList name="selAdvisedMainSwitchNeedsTurningOff" ID="selAdvisedMainSwitchNeedsTurningOff" runat="Server" HeaderText="Advised Main Switch Needs TurningOff" onchange="AdvisedMainSwitchNeedsTurningOffChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Safety Certificate Required?" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="SafetyCertificateRequired" runat="server" Text='<%# Bind("SafetyCertificateRequired") %>'></asp:TextBox>
                                    <asp:DropDownList name="selSafetyCertificateRequired" ID="selSafetyCertificateRequired" runat="Server" HeaderText="Safety Certificate Required" onchange="SafetyCertificateRequiredChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Elec Status" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ElecStatus" runat="server" Text='<%# Bind("ElecStatus") %>'></asp:TextBox>
                                    <asp:DropDownList name="selElecStatus" ID="selElecStatus" runat="Server" HeaderText="Elec Status" onchange="ElecStatusChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Accepted">Accepted</asp:ListItem>
                                        <asp:ListItem Value="Rejected">Rejected</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Gas Status" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="GasStatus" runat="server" Text='<%# Bind("GasStatus") %>'></asp:TextBox>
                                    <asp:DropDownList name="selGasStatus" ID="selGasStatus" runat="Server" HeaderText="Gas Status" onchange="GasStatusChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Accepted">Accepted</asp:ListItem>
                                        <asp:ListItem Value="Rejected">Rejected</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Reason" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="Reason" runat="server" Text='<%# Bind("Reason") %>'></asp:TextBox>
                                    <asp:DropDownList name="selReason" ID="selReason" runat="Server" HeaderText="Reason" onchange="ReasonChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="NMI unable to be located">NMI unable to be located</asp:ListItem>
                                        <asp:ListItem Value="Solar tariffs/product not available">Solar tariffs/product not available</asp:ListItem>
                                        <asp:ListItem Value="Existing customer on same product">Existing customer on same product</asp:ListItem>
                                        <asp:ListItem Value="Incorrect/missing information">Incorrect/missing information</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Existing TRUEnergy Customer? *" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                <asp:TextBox ID="ExistingTRUEnergyCustomer" runat="server" Text='<%# Bind("ExistingTRUEnergyCustomer") %>'></asp:TextBox>
                                    <asp:DropDownList name="selExistingTRUEnergyCustomer" ID="selExistingTRUEnergyCustomer" runat="Server" HeaderText="Existing TRUEnergy Customer" onchange="ExistingTRUEnergyCustomerChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="YES">YES</asp:ListItem>
                                        <asp:ListItem Value="NO">NO</asp:ListItem>
                                    </asp:DropDownList>
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="Additional Question" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <EditItemTemplate>
                                Do you have any other properties we could look at for you?
                                <asp:TextBox ID="AdditionalQuestion" runat="server" Text='<%# Bind("AdditionalQuestion") %>'></asp:TextBox>
                                    <asp:DropDownList name="selAdditionalQuestion" ID="selAdditionalQuestion" runat="Server" HeaderText="Additional Question" onchange="AdditionalQuestionChanged()">
                                        <asp:ListItem Value="">Select...</asp:ListItem>
                                        <asp:ListItem Value="Investment property">Investment property</asp:ListItem>
                                        <asp:ListItem Value="Business">Business</asp:ListItem>
                                        <asp:ListItem Value="Holiday home">Holiday home</asp:ListItem>
                                        <asp:ListItem Value="Investment property & business">Investment property & business</asp:ListItem>
                                        <asp:ListItem Value="Other">Other</asp:ListItem>
                                    </asp:DropDownList>
                                    <input type="button" ID="CheckBotton" runat="server" value="Validate" onclick="checkbottonclick()" visible="false" />
                                </EditItemTemplate>
                            </asp:TemplateField>

                            <asp:TemplateField HeaderText="SSE Operator Comments" HeaderStyle-BackColor="#CCFFFF" ItemStyle-BackColor="#CCFFFF">
                                <ItemTemplate>
                                    <asp:Label ID="lblSSE_Operator_Feedback" runat="server" Text='<%# bind("SSE_Operator_Feedback")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="SSE_Operator_Feedback" runat="server"  Rows="5" Cols="40" Width="97%" TextMode="MultiLine" Text='<%# Bind("SSE_Operator_Feedback") %>'></asp:TextBox>
                                </EditItemTemplate>
                            </asp:TemplateField>
                            

                            <asp:TemplateField HeaderText="Account Holder Company Name" Visible="false">
                                <ItemTemplate>
                                    <asp:Label ID="lblAccountHolderCompanyName" runat="server" Text='<%# bind("AccountHolderCompanyName")%>' />
                                </ItemTemplate>
                                <EditItemTemplate>
                                    <asp:TextBox ID="AccountHolderCompanyName" runat="server" Text='<%# Bind("AccountHolderCompanyName") %>'></asp:TextBox>
                                    <input type="button" ID="CopyBotton" runat="server" value="Copy Info" onclick="copybottonclick()"/>
                                </EditItemTemplate>
                            </asp:TemplateField>


                            <asp:TemplateField ItemStyle-HorizontalAlign="Left" ItemStyle-Font-Bold="true" ItemStyle-ForeColor="Red">
                                <EditItemTemplate>
                                    <asp:Button ID="InsertButton" runat="server" Text="Insert" CommandName="insert">
                                    </asp:Button>
                                    <asp:Button ID="UpdateButton" runat="server" Text="Update"
                                        OnClick="UpdateButton_Click">
                                    </asp:Button>
                                    <asp:Button ID="DeleteButton" runat="server" Text="Delete" CommandName="delete"
                                        OnClientClick="return confirm ( 'Are you sure to delete this record?' )">
                                    </asp:Button>
                                    <asp:Button ID="CancelButton" runat="server" Text="Cancel" CommandName="cancel">
                                    </asp:Button>
                                </EditItemTemplate>
                            <ItemStyle HorizontalAlign="Left" Font-Bold="True" ForeColor="Red"></ItemStyle>
                            </asp:TemplateField>

                        </Fields>

                    <PagerStyle CssClass="pgr"></PagerStyle>
                    </asp:DetailsView>

                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                        SelectCommand="Select * FROM tbluser WHERE userID = @userID" 
                        DeleteCommand="Delete FROM tbluser WHERE userID = @userID"
                        InsertCommand="INSERT INTO tbluser ( 
        FirstName,
        LastName,
        Email,
        CompanyName, 
        CompanyABN,
        Street,
		Suburb,
        StateName, 
        Postcode,  
        Phone,  
        Mobile,     
        CurrentProvider,   
        PromotionCode,
        AdminFee,
        Comments,
        LeadSource,
        TypeOrg, 
        PreferredDay,
        PreferredTime,
        GolfClub,
        G2G_Solar,
        Competition,
        TotalSites,
		ElecMonthQuarter,
		GasMonthQuarter,
        ElecMonthQuarterSpend,
        GasMonthQuarterSpend,
        ElecTotalAnnualSpend,
        GasTotalAnnualSpend,
        TotalAnnualSpend,
        AccountStatus,
        StatusName,
        AccountStatusHistory,
        ProviderID,
        SourceCode,       
        OperatorSSE,
        VendorID,
        DateConverted,
        MoverSwicher,
        RESI_SME,
        ElectricityConversion,
        GasConversion,
        MoveInDate,     
        ID_Type,
        ID_Number,
        ID_Expiry,
        FirstAccountHolderTitle,
        FirstAccountHolderFirstName,
        FirstAccountHolderSurname,
        FirstAccountHolderDOB,      
        SecondAccountHolderTitle,
        SecondAccountHolderFirstName,
        SecondAccountHolderSurname,
        SecondAccountHolderDOB,
        SupplyAddress,
        SupplyAddressSuburb,
        SupplyAddressState,
        SupplyAddressPostcode,
        TenantOwner,
        Elec,
        Gas,
        ProductType,
        NoOfPeopleInHouse,
        ConcessionCardType,
        ConcessionCardEntitlement,
        ConcessionCardNo,
        ConcessionCardExp,
        NameOnConcessionCard,
        NMI,
        MIRN,
        AnyHazards,
        AnyAccessRequirements,
        SpecialInstructionsForAccess,
        AdvisedMainSwitchNeedsTurningOff,
        SafetyCertificateRequired,
        ElecStatus,
        GasStatus,
        Reason,
        ExistingTRUEnergyCustomer,
        AdditionalQuestion,
        SSE_Operator_Feedback
        ) VALUES (
        @FirstName,
        @LastName,
        @Email,
        @CompanyName, 
        @CompanyABN,
        @Street,
		@Suburb,
        @StateName, 
        @Postcode,  
        @Phone,  
        @Mobile,     
        @CurrentProvider,   
        @PromotionCode,
        @AdminFee,
        @Comments,
        @LeadSource,
        @TypeOrg, 
        @PreferredDay,
        @PreferredTime,
        @GolfClub,
        @G2G_Solar,
        @Competition,
        @TotalSites,
		@ElecMonthQuarter,
		@GasMonthQuarter,
        @ElecMonthQuarterSpend,
        @GasMonthQuarterSpend,
        @ElecTotalAnnualSpend,
        @GasTotalAnnualSpend,
        @TotalAnnualSpend,
        @AccountStatus,
        @StatusName,
        @AccountStatusHistory,
        @ProviderID,
        @SourceCode,       
        @OperatorSSE,
        @VendorID,
        @DateConverted,
        @MoverSwicher,
        @RESI_SME,
        @ElectricityConversion,
        @GasConversion,
        @MoveInDate,     
        @ID_Type,
        @ID_Number,
        @ID_Expiry,
        @FirstAccountHolderTitle,
        @FirstAccountHolderFirstName,
        @FirstAccountHolderSurname,
        @FirstAccountHolderDOB,      
        @SecondAccountHolderTitle,
        @SecondAccountHolderFirstName,
        @SecondAccountHolderSurname,
        @SecondAccountHolderDOB,
        @SupplyAddress,
        @SupplyAddressSuburb,
        @SupplyAddressState,
        @SupplyAddressPostcode,
        @TenantOwner,
        @Elec,
        @Gas,
        @ProductType,
        @NoOfPeopleInHouse,
        @ConcessionCardType,
        @ConcessionCardEntitlement,
        @ConcessionCardNo,
        @ConcessionCardExp,
        @NameOnConcessionCard,
        @NMI,
        @MIRN,
        @AnyHazards,
        @AnyAccessRequirements,
        @SpecialInstructionsForAccess,
        @AdvisedMainSwitchNeedsTurningOff,
        @SafetyCertificateRequired,
        @ElecStatus,
        @GasStatus,
        @Reason,
        @ExistingTRUEnergyCustomer,
        @AdditionalQuestion,
        @SSE_Operator_Feedback
        )"
        UpdateCommand="UPDATE tbluser SET     
        FirstName = @FirstName,
        LastName = @LastName,
        Email = @Email,
        CompanyName = @CompanyName, 
        CompanyABN = @CompanyABN,
        Street = @Street,
		Suburb = @Suburb,
        StateName = @StateName, 
        Postcode = @Postcode,  
        Phone = @Phone,  
        Mobile = @Mobile,     
        CurrentProvider = @CurrentProvider,   
        PromotionCode = @PromotionCode,
        AdminFee = @AdminFee, 
        Comments = @Comments,
        LeadSource = @LeadSource,
        TypeOrg = @TypeOrg, 
        PreferredDay=@PreferredDay,
        PreferredTime=@PreferredTime,
        GolfClub=@GolfClub,
        G2G_Solar=@G2G_Solar,
        Competition=@Competition,
        TotalSites=@TotalSites,
		ElecMonthQuarter=@ElecMonthQuarter,
		GasMonthQuarter=@GasMonthQuarter,
        ElecTotalAnnualSpend=@ElecTotalAnnualSpend,
        GasTotalAnnualSpend=@GasTotalAnnualSpend,
        ElecMonthQuarterSpend=@ElecMonthQuarterSpend,
        GasMonthQuarterSpend=@GasMonthQuarterSpend,
        TotalAnnualSpend=@TotalAnnualSpend,
        AccountStatus=@AccountStatus,
        StatusName=@StatusName,
        AccountStatusHistory=@AccountStatusHistory,
        ProviderID=@ProviderID,
        SourceCode=@SourceCode,       
        OperatorSSE=@OperatorSSE,
        VendorID=@VendorID,
        DateConverted=@DateConverted,
        MoverSwicher=@MoverSwicher,
        RESI_SME=@RESI_SME,
        ElectricityConversion=@ElectricityConversion,
        GasConversion=@GasConversion,
        MoveInDate=@MoveInDate,     
        ID_Type=@ID_Type,
        ID_Number=@ID_Number,
        ID_Expiry=@ID_Expiry,
        FirstAccountHolderTitle=@FirstAccountHolderTitle,
        FirstAccountHolderFirstName=@FirstAccountHolderFirstName,
        FirstAccountHolderSurname=@FirstAccountHolderSurname,
        FirstAccountHolderDOB=@FirstAccountHolderDOB,      
        SecondAccountHolderTitle=@SecondAccountHolderTitle,
        SecondAccountHolderFirstName=@SecondAccountHolderFirstName,
        SecondAccountHolderSurname=@SecondAccountHolderSurname,
        SecondAccountHolderDOB=@SecondAccountHolderDOB,
        SupplyAddress=@SupplyAddress,
        SupplyAddressSuburb=@SupplyAddressSuburb,
        SupplyAddressState=@SupplyAddressState,
        SupplyAddressPostcode=@SupplyAddressPostcode,
        TenantOwner=@TenantOwner,
        Elec=@Elec,
        Gas=@Gas,
        ProductType=@ProductType,
        NoOfPeopleInHouse=@NoOfPeopleInHouse,
        ConcessionCardType=@ConcessionCardType,
        ConcessionCardEntitlement=@ConcessionCardEntitlement,
        ConcessionCardNo=@ConcessionCardNo,
        ConcessionCardExp=@ConcessionCardExp,
        NameOnConcessionCard=@NameOnConcessionCard,
        NMI=@NMI,
        MIRN=@MIRN,
        AnyHazards=@AnyHazards,
        AnyAccessRequirements=@AnyAccessRequirements,
        SpecialInstructionsForAccess=@SpecialInstructionsForAccess,
        AdvisedMainSwitchNeedsTurningOff=@AdvisedMainSwitchNeedsTurningOff,
        SafetyCertificateRequired=@SafetyCertificateRequired,
        ElecStatus=@ElecStatus,
        GasStatus=@GasStatus,
        Reason=@Reason,
        ExistingTRUEnergyCustomer=@ExistingTRUEnergyCustomer,
        AdditionalQuestion=@AdditionalQuestion,
        SSE_Operator_Feedback=@SSE_Operator_Feedback
        WHERE userID = @userID">
                        <SelectParameters>
							<asp:ControlParameter ControlID="GridView1" Name="UserID" PropertyName="selectedvalue" /> 
                        </SelectParameters>
                        <DeleteParameters>
                            <asp:Parameter Name="userID" />
                        </DeleteParameters>
                        <UpdateParameters>
                        </UpdateParameters>
                        <InsertParameters>
                        </InsertParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
                    ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                    SelectCommand="Select * FROM SourceCodeRESI">
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
                    ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                    SelectCommand="Select * FROM SourceCodeSME">
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource7" runat="server" 
                    ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                    SelectCommand="Select * FROM ProductTypeRESI">
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource8" runat="server" 
                    ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                    SelectCommand="Select * FROM ProductTypeSME">
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource6" runat="server" 
                    ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                    SelectCommand="Select * FROM tblAccountStatus">
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource35" runat="server" 
                    ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                    SelectCommand="Select * FROM tblPromotionCode order by PromotionCodeName" >
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource36" runat="server" 
                    ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                    SelectCommand="Select * FROM tblOperator">
                    </asp:SqlDataSource>
                    
                    <asp:SqlDataSource ID="SqlDataSource37" runat="server" 
                    ConnectionString='<%$ ConnectionStrings:SQLServer2005DBConnectionString %>'
                    SelectCommand="Select * FROM tblCurrentProvider">
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource0" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
                    SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE FROM tblUser where StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">                 
                    <SelectParameters>
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource9" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE FROM tblUser where FirstName=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource10" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE FROM tblUser where LastName=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource11" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where StateName=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList3" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource12" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where AccountStatus=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList1" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource13" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where (PromotionCode like '%'+ @Value + '%' or LeadSource like '%'+ @Value + '%') and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList2" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource14" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where Email like '%'+ @Value + '%' and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource15" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where UserID=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource16" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where StatusName<>@Status1 and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
                    <SelectParameters>
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource17" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where FirstName=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource18" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where LastName=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource19" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where StateName=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList3" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource20" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where AccountStatus=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList1" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource21" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where (PromotionCode like '%'+ @Value + '%' or LeadSource like '%'+ @Value + '%') and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList2" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource22" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where Email like '%'+ @Value + '%' and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource23" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where (Phone=@Value or Mobile=@Value) and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource24" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where CompanyName like '%'+ @Value + '%' and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource25" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where CurrentProvider like '%'+ @Value + '%' and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList4" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource26" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where (Phone=@Value or Mobile=@Value) and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource27" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where CompanyName like '%'+ @Value + '%' and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource28" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where CurrentProvider like '%'+ @Value + '%' and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList4" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource29" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where (UserID like '%'+ @Value + '%'or FirstName=@Value or LastName=@Value or CompanyName like '%'+ @Value + '%' or Email=@Value or Phone=@Value or StateName=@Value or StatusName=@Value or PostCode=@Value or CurrentProvider like '%'+ @Value + '%' or PromotionCode like '%'+ @Value + '%') and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource30" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where (UserID like '%'+ @Value + '%'or FirstName=@Value or LastName=@Value or CompanyName like '%'+ @Value + '%' or Email=@Value or Phone=@Value or StateName=@Value or StatusName=@Value or PostCode=@Value or CurrentProvider like '%'+ @Value + '%' or PromotionCode like '%'+ @Value + '%') and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="SearchTextBox" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource31" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where (PreferredDay >= @Value1 and PreferredDay <= @Value2) and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="Date1" Name="Value1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="Date2" Name="Value2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource32" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where (PreferredDay >= @Value1 and PreferredDay <= @Value2) and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="Date1" Name="Value1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="Date2" Name="Value2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource33" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where TypeOrg=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList5" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource34" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where TypeOrg=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList5" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where OperatorSSE=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList6" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where OperatorSSE=@Value and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="DropDownList6" Name="Value" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource38" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"              
                    SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where PromotionCode=@Value3 and InsertDate>=@Value1 and InsertDate<=@Value2 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
                    <SelectParameters>
                    <asp:ControlParameter ControlID="Date1" Name="Value1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="Date2" Name="Value2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="DropDownList2" Name="Value3" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource39" runat="server" 
					ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"             
					SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where (InsertDate >= @Value1 and InsertDate <= @Value2) and StatusName<>@Status1 and StatusName<>@Status2 and StatusName<>@Status3 and StatusName<>@Status4 and StatusName<>@Status5 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
					<SelectParameters>
                    <asp:ControlParameter ControlID="Date1" Name="Value1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="Date2" Name="Value2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label10" Name="Status1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label11" Name="Status2" Type="String" PropertyName="Text" />
                    <asp:ControlParameter ControlID="label17" Name="Status3" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label18" Name="Status4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="label19" Name="Status5" Type="String" PropertyName="Text" />  
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <asp:SqlDataSource ID="SqlDataSource40" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:SQLServer2005DBConnectionString %>"              
                    SelectCommand = "SELECT UserID, FirstName, LastName, TypeOrg, CompanyName, Email, Phone, PromotionCode, StateName, Postcode, StatusName, InsertDate, DateConverted, PreferredDay, PreferredTime, G2G_Solar, OperatorSSE  FROM tblUser where PromotionCode=@Value3 and StatusName=@Value4 and InsertDate>=@Value1 and InsertDate<=@Value2 order by UserID desc"
                    DeleteCommand = "DELETE from tblUser where UserID=@UserID">
                    <SelectParameters>
                    <asp:ControlParameter ControlID="Date1" Name="Value1" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="Date2" Name="Value2" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="DropDownList1" Name="Value4" Type="String" PropertyName="Text" /> 
                    <asp:ControlParameter ControlID="DropDownList2" Name="Value3" Type="String" PropertyName="Text" /> 
                    </SelectParameters>
                    </asp:SqlDataSource>

                    <br />
                    </div>
    </div>
    </form>
</body>

<script src="WdatePicker.js" type="text/javascript"></script>

<script src="http://ajax.microsoft.com/ajax/jquery/jquery-1.4.2.min.js" type="text/javascript"></script>

<script src="date.f-0.5.0-min.js" type="text/javascript"></script>

<script src="main.js" type="text/javascript"></script>

</html>
